﻿create proc capmenu_loadgridnhommenu
@MaNhom int
as
select cast(0 as bit) as Chon,MaNhomMenuND,TenNhomMenuND from DanhMuc_NhomMenuNguoiDung
Where MaNhomMenuND not in (select MaNhomMenuND from QuanTri_CapQuyenNguoiDungSuDungMenu Where MaNhomUser=@MaNhom)
union
select cast(1 as bit) as Chon,MaNhomMenuND,TenNhomMenuND from DanhMuc_NhomMenuNguoiDung
Where MaNhomMenuND in (select MaNhomMenuND from QuanTri_CapQuyenNguoiDungSuDungMenu Where MaNhomUser=@MaNhom)